--oȤMסB~ױM׽sBHsY

SELECT A.BPPNM, B.BPPYN, C.RANUM
FROM BPRJ A 
  INNER JOIN BPAA B ON A.BPPNM=B.BPPNM
  INNER JOIN RASN C ON B.BPPYN=C.RAPYN
WHERE B.BPYER=97


-- d [Z ֿnɥ
select RPREN AS [Z渹, RPRDT AS , RPRTM AS }lɶ, RPETM AS ɶ, RPDOC Ƶ, RPTCT ɼ, RPUST wR
from RPAR WHERE RPTYP='11' AND RPNUM='00989'

-- d а ɥ
select RPREN AS а渹, RPRDT AS , RPRTM AS }lɶ, RPETM AS ɶ, RPDOC Ƶ, RPTCT ɼ, RPUST wR
from RPAR WHERE RPTYP='00' AND RPNUM='00989'

-- d Rɥ
SELECT RPREN AS а渹, RPREX AS [Z渹, RPTCT AS RPɼ FROM RPAC WHERE RPREN= '2012061090'
SELECT RPREN AS а渹, RPREX AS [Z渹, RPTCT AS RPɼ FROM RPAC WHERE RPREN= '2012071108'
SELECT RPREN AS а渹, RPREX AS [Z渹, RPTCT AS RPɼ FROM RPAC WHERE RPREN= '2012071235'